﻿create table [dbo].[Server]
(
	[Id] uniqueidentifier not null
		constraint PK_Server primary key nonclustered
		constraint DF_Server_Id default newid(),
	[CreatedOn] datetimeoffset not null
		constraint UQ_Server_CreatedOn unique clustered, -- add's a risk when creating two at the EXACT same time, but is a better clustered index as the guid
	[Name] nvarchar(64) not null, 
    [MaxMegabytes] int null, -- when not set, it's variable 

	-- references
	[MachineId] uniqueidentifier not null
		constraint FK_Server_Machine foreign key references [dbo].[Machine]( [Id] )
);
